{
  "properties" : { },
  "id" : "39ead90b432e46b1b1ee139c4767e9fe",
  "script" : null,
  "groupId" : "43da313fdeaa495798cf783e6cf83479",
  "name" : "查询应用ip",
  "createTime" : 1727070858878,
  "updateTime" : 1726020021249,
  "lock" : "1",
  "createBy" : "ndmp",
  "updateBy" : "ndmp",
  "path" : "getAppIp",
  "method" : "POST",
  "parameters" : [ ],
  "options" : [ ],
  "requestBody" : "{\"gateway\":\"1.1.3.0\",\r\n\"size\":10,\r\n\"current\":1\r\n\r\n}",
  "headers" : [ ],
  "paths" : [ ],
  "responseBody" : "{\n    \"status\": 200,\n    \"message\": \"success\",\n    \"data\": {\n        \"total\": 10,\n        \"current\": 1,\n        \"size\": 10,\n        \"records\": [\n            {\n                \"id\": \"1833410938070503437\",\n                \"ip\": \"1.1.3.1\",\n                \"ipType\": \"26\",\n                \"groupId\": \"18ac461de04346c78bf459a881a03ab3\",\n                \"mark\": \"\",\n                \"usageStatus\": \"\",\n                \"allocationStatus\": \"\",\n                \"realTime\": \"1\",\n                \"businessName\": \"\",\n                \"gateway\": \"1.1.3.0\",\n                \"masterIp\": \"\",\n                \"rowId\": \"1\"\n            },\n            {\n                \"id\": \"1833410938070503446\",\n                \"ip\": \"1.1.3.10\",\n                \"ipType\": \"26\",\n                \"groupId\": \"18ac461de04346c78bf459a881a03ab3\",\n                \"mark\": \"\",\n                \"usageStatus\": \"\",\n                \"allocationStatus\": \"\",\n                \"realTime\": \"1\",\n                \"businessName\": \"\",\n                \"gateway\": \"1.1.3.0\",\n                \"masterIp\": \"\",\n                \"rowId\": \"2\"\n            },\n            {\n                \"id\": \"1833410938070503438\",\n                \"ip\": \"1.1.3.2\",\n                \"ipType\": \"26\",\n                \"groupId\": \"18ac461de04346c78bf459a881a03ab3\",\n                \"mark\": \"\",\n                \"usageStatus\": \"\",\n                \"allocationStatus\": \"\",\n                \"realTime\": \"1\",\n                \"businessName\": \"\",\n                \"gateway\": \"1.1.3.0\",\n                \"masterIp\": \"\",\n                \"rowId\": \"3\"\n            },\n            {\n                \"id\": \"1833410938070503439\",\n                \"ip\": \"1.1.3.3\",\n                \"ipType\": \"26\",\n                \"groupId\": \"18ac461de04346c78bf459a881a03ab3\",\n                \"mark\": \"\",\n                \"usageStatus\": \"\",\n                \"allocationStatus\": \"\",\n                \"realTime\": \"1\",\n                \"businessName\": \"\",\n                \"gateway\": \"1.1.3.0\",\n                \"masterIp\": \"\",\n                \"rowId\": \"4\"\n            },\n            {\n                \"id\": \"1833410938070503440\",\n                \"ip\": \"1.1.3.4\",\n                \"ipType\": \"26\",\n                \"groupId\": \"18ac461de04346c78bf459a881a03ab3\",\n                \"mark\": \"\",\n                \"usageStatus\": \"\",\n                \"allocationStatus\": \"\",\n                \"realTime\": \"1\",\n                \"businessName\": \"\",\n                \"gateway\": \"1.1.3.0\",\n                \"masterIp\": \"\",\n                \"rowId\": \"5\"\n            },\n            {\n                \"id\": \"1833410938070503441\",\n                \"ip\": \"1.1.3.5\",\n                \"ipType\": \"26\",\n                \"groupId\": \"18ac461de04346c78bf459a881a03ab3\",\n                \"mark\": \"\",\n                \"usageStatus\": \"\",\n                \"allocationStatus\": \"\",\n                \"realTime\": \"1\",\n                \"businessName\": \"\",\n                \"gateway\": \"1.1.3.0\",\n                \"masterIp\": \"\",\n                \"rowId\": \"6\"\n            },\n            {\n                \"id\": \"1833410938070503442\",\n                \"ip\": \"1.1.3.6\",\n                \"ipType\": \"26\",\n                \"groupId\": \"18ac461de04346c78bf459a881a03ab3\",\n                \"mark\": \"\",\n                \"usageStatus\": \"\",\n                \"allocationStatus\": \"\",\n                \"realTime\": \"1\",\n                \"businessName\": \"\",\n                \"gateway\": \"1.1.3.0\",\n                \"masterIp\": \"\",\n                \"rowId\": \"7\"\n            },\n            {\n                \"id\": \"1833410938070503443\",\n                \"ip\": \"1.1.3.7\",\n                \"ipType\": \"26\",\n                \"groupId\": \"18ac461de04346c78bf459a881a03ab3\",\n                \"mark\": \"\",\n                \"usageStatus\": \"\",\n                \"allocationStatus\": \"\",\n                \"realTime\": \"1\",\n                \"businessName\": \"\",\n                \"gateway\": \"1.1.3.0\",\n                \"masterIp\": \"\",\n                \"rowId\": \"8\"\n            },\n            {\n                \"id\": \"1833410938070503444\",\n                \"ip\": \"1.1.3.8\",\n                \"ipType\": \"26\",\n                \"groupId\": \"18ac461de04346c78bf459a881a03ab3\",\n                \"mark\": \"\",\n                \"usageStatus\": \"\",\n                \"allocationStatus\": \"\",\n                \"realTime\": \"1\",\n                \"businessName\": \"\",\n                \"gateway\": \"1.1.3.0\",\n                \"masterIp\": \"\",\n                \"rowId\": \"9\"\n            },\n            {\n                \"id\": \"1833410938070503445\",\n                \"ip\": \"1.1.3.9\",\n                \"ipType\": \"26\",\n                \"groupId\": \"18ac461de04346c78bf459a881a03ab3\",\n                \"mark\": \"\",\n                \"usageStatus\": \"\",\n                \"allocationStatus\": \"\",\n                \"realTime\": \"1\",\n                \"businessName\": \"\",\n                \"gateway\": \"1.1.3.0\",\n                \"masterIp\": \"\",\n                \"rowId\": \"10\"\n            }\n        ]\n    }\n}",
  "description" : null,
  "requestBodyDefinition" : null,
  "responseBodyDefinition" : null
}
================================
  import cn.hutool.core.net.Ipv4Util

  List ipList = Ipv4Util.list(body.gateway, 26, false);

  return db.page("""
          select * from ndmp_ip_source_manager where ip in
        <foreach collection="ipList" index="index" item="ip" open="(" close=")" separator=",">
            #{ip}
        </foreach>
        """, body.size, body.current - 1)